--------------------------------------------------------
--  DDL for Table ACCOUNT_PASSWORD_AUDIT
--------------------------------------------------------

  CREATE TABLE "ACCOUNT_PASSWORD_AUDIT" 
   (	
	"APPLICATION_KEY" VARCHAR2(36 BYTE), 
  "ID" VARCHAR2(5 BYTE), 
	"USER_NAME" VARCHAR2(50 BYTE), 
	"PASSWORD" VARCHAR2(128 BYTE), 
	"CREATION_DATE" DATE, 
	"ACTIVE" CHAR(1 BYTE)
   );
--------------------------------------------------------
--  DDL for Index ACCOUNT_PASSWORD_AUDIT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "ACCOUNT_PASSWORD_AUDIT_PK" ON "ACCOUNT_PASSWORD_AUDIT" ("APPLICATION_KEY", "ID", "USER_NAME");
--------------------------------------------------------
--  Constraints for Table ACCOUNT_PASSWORD_AUDIT
--------------------------------------------------------

  ALTER TABLE "ACCOUNT_PASSWORD_AUDIT" MODIFY ("CREATION_DATE" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_PASSWORD_AUDIT" ADD CONSTRAINT "ACCOUNT_PASSWORD_AUDIT_PK" PRIMARY KEY ("APPLICATION_KEY", "ID", "USER_NAME");
  ALTER TABLE "ACCOUNT_PASSWORD_AUDIT" MODIFY ("PASSWORD" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_PASSWORD_AUDIT" MODIFY ("USER_NAME" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_PASSWORD_AUDIT" MODIFY ("ID" NOT NULL ENABLE);
